Entity DefinitionLogical Name : ItemProcessingEquipment |
|---|
| Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
|---|---|---|---|---|---|
| EquipmentID (FK)(PK) | The fixed asset number assigned by the retailer for this particular piece of equipment. | ID_EQ | Identity | integer | Equipment(AS_EQ) |
| TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | ItemProcessingTransaction(TR_ITM_PRCS) |
| Parent Entity | Verb Phrase | Child Entity |
|---|---|---|
| ItemProcessingTransaction | uses | ItemProcessingEquipment |
| Equipment | is used in | ItemProcessingEquipment |
| Logical View |
|---|
| Logical 21000 - Fresh Item Management Macro View |